Overview/Introduction to Update HSN Code in the Multiple items in Marg ERP Software

Steps to Export Item List with their HSN Code in Marg ERP Software

Steps to Update HSN Code in the Multiple Items in Marg ERP Software

OVERVIEW/INTRODUCTION TO UPDATE HSN CODE IN THE MULTIPLE ITEMS IN MARG ERP SOFTWARE

• With the help of Marg ERP Software, the user can update the HSN Code in the multiple items through excel at a single point of time.
• This option helps the user to import multiple data at one point of time without creating any method.

• This saves the time of the customer as there is no needs to update HSN Code each and every separate item in the software.

STEPS TO EXPORT ITEM LIST WITH THEIR HSN CODE IN MARG ERP SOFTWARE

• Go to Masters > Ease of GST > Item GST%/HSN/SAC/Rates Updation.   

• An Item GST%/HSN/SAC/Rates updation window will appear. In 'Stock Status', the user will select 'Whole.

• Then click on 'Accept'.

• Then an 'Item wise HSN/SAC master' window will appear then press 'F10' key on it.

• A 'Bill' window will appear.

• Select 'Export' in order to export item list with their HSN code then press 'Enter' key on it.

• Now the user can view the path of the report where the exported excel will get saved and it can also be edited (If needed).

• Then press 'Enter' key.
  

After following the above steps, the item list will get saved with their HSN code.

• Now the user can update the HSN code in the exported excel as per the requirement.

• Suppose, we have changed the HSN Code of all the items in the excel.

STEPS TO UPDATE HSN CODE IN THE MULTIPLE ITEMS IN MARG ERP SOFTWARE

• Go to Masters > Ease of GST > Item GST%/HSN/SAC/Rates Updation.   

• An 'Item GST%/HSN/SAC/Rates updation' window will appear.

• Then click on 'Accept'.

• Then an 'Item wise HSN/SAC Master' window will appear then press 'F10' key on it.

• A 'Bill' window will appear.

• Select 'Import' in order to import HSN code in the multiple items.

• An alert of 'Only you can import HSN Code, Tax type & Tax%' will appear. Click on 'Ok'.

• Now select that location in which the exported excel sheet of the item master has been saved.

• Then click on ‘Select’.

• An 'Import' window will appear.

• Then the selected path will get automatically picked by the software beside the 'Import' field. Press 'Enter'key.

• An 'Importing Items' window will appear in which the user can view the data is being imported.

After following the above steps, the user can view that the data has been imported properly.

The user can also update HSN in All Items by following the below steps:

1. Go to Reports > Management Reports > Utilities > Multi Editing > Tax% & HSN/SAC.

2. A 'Select Company' window will appear. Press 'Spacebar' key to select the company Or press Asterisk (*) key to select all company and then press 'Enter' on it.

3. In next window all Tax Rate will display in which user will press 'Enter' key on selected Tax Rate.

4. Now, the user can change the SGST,CGST & HSN Code as per the requirement.

5. Then press 'ESC' key to save the changes.

6. A 'Tax Structure' window will appear. In 'Save Both/Sale/Purchase/Exit', the user will select whether the changes needs to save in previous Sale and Purchase Bill or not and press 'Enter' key.

After following the above steps, the HSN will be changed in All Items in Marg Software.

1. Go to Masters > Ease of GST > Item GST%/HSN/SAC/Rates Updation.

2. An 'Item GST%/HSN/SAC/Rates' updation window will appear. Click on 'Accept'.

3. An 'Item wise HSN/SAC Master' window will appear the user will press 'F6' key on it.

4. A 'MRP To Rate formula' window will appear where the user will select 'Tax % & HSN Code'.  

5. In next window all Tax Rate will display in which user will press 'Enter' key on selected Tax Rate and press 'Enter' key.

6. Now, the user will change the SGST,CGST & HSN Code as per the requirement.

7. The user will press 'ESC' key to save the changes.

8. A 'Tax structure' window will appear.

9. In 'Save Both/Sale/Purchase/Exit', the user will select whether the changes will save in previous sale and purchase bill or not and press 'Enter' key.